Efficient Transformation of a Natural Language Query to SQL for Urdu
نویسندگان
چکیده
It is a long term desire of the computer users to minimize the communication gap between the computer and a human. Natural Language Interfaces to Databases (NLIDBs) is one of the mechanisms to pull off this goal. In NLIDBs the question is asked in simple daily life human language and the answer is given in the same language. This research paper is about NLIDBs for Urdu language. An algorithm is developed that efficiently maps a natural language query, entered in Urdu, to an SQL (Structured Query Language) statement. The algorithm has been implemented in Visual C#.NET and tested on a database containing Student Information System and Employee Information System. The program correctly maps 85% natural language queries.
منابع مشابه
انتخاب مناسب‌ترین زبان پرس‌وجو برای استفاده از فرا‌‌پیوندها جهت استخراج داده‌ها در حالت دیتالوگ در سامانه پایگاه داده استنتاجی DES
Deductive Database systems are designed based on a logical data model. Data (as opposed to Relational Databases Management System (RDBMS) in which data stored in tables) are saved as facts in a Deductive Database system. Datalog Educational System (DES) is a Deductive Database system that Datalog mode is the default mode in this system. It can extract data to use outer joins with three query la...
متن کاملSPATIAL KNOWLEDGE EXTRACTION FROM GEOGRAPHICAL DATABASES An approach based on the Controlled English Query Language Geo-Q and Conceptual Graphs
Conceptualizing spatial relations through natural language seems to be closer to the model humans adopt for spatial reasoning. Controlled languages, which are subsets of natural ones, could be used in order to overcome the difficulties that emanate from the required experience in programming languages. In this paper, we propose a methodology in which questions are expressed in a new controlled ...
متن کاملIntelligent Multidimensional Database Interface
Zagazig, Egypt ABSTRACT In the present computing world, most new-generation database applications need for intelligent interface to enhance efficient interactions between database and the users. Database query language SQL could be difficult to the non-expert users and learning these formal queries takes a lot of time. In this paper, we discussed mapping of natural language queries to SQL rathe...
متن کاملClassification of Attributes in a Natural Language Query into Different SQL Clauses
Attribute information in a natural language query is one of the key features for converting a natural language query into a Structured Query Language1 (SQL) in Natural Language Interface to Database systems. In this paper, we explore the task of classifying the attributes present in a natural language query into different SQL clauses in a SQL query. In particular, we investigate the effectivene...
متن کاملBidirectional Attention for SQL Generation
Generating structural query language (SQL) queries from natural language is a long-standing open problem and has been attracting considerable interest recently, driven by the explosive development of deep learning techniques. Toward solving the problem, we leverage the structure of SQL queries and present a sketch-based approach or synthesizing way to solve this problem, which turns the solving...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2008